SUPPORT / SAMPLES & SAS NOTES
Problem Note 36333: Automatic mapping does not occur for columns referenced in expressions
 |  |  |  |  |
In SAS® Data Integration Studio transformations, target columns can be defined as derived columns that are populated based on expressions. Often these expressions include references to columns from source tables. In previous releases of SAS Data Integration Studio when you exited the Expression Builder window, mappings were automatically created between the source columns and the derived column. This automatic mapping no longer takes place; therefore, you must manually perform these process.
If these mappings are not manually defined, the following warning will be generated during job execution and the job will not complete with a zero return code.
WARNING: Mapped source columns do not match columns used in expression.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||